UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y+l/mHPSBWPmrAh8YhyMRVLnmt9Mizw0SOCYeIE4Qq0='
WHERE
key_id = 'd96ba4250318a25bed0176fbf125119fa64f444eabeb70ea5f5134cef4bb69cf'
AND (
token = 'y+l/mHPSBWPmrAh8YhyMRVLnmt9Mizw0SOCYeIE4Qq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)