UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WrmhQAmLGwW375227a2CcYp8a1SvmMhmjlpmwlH3fV4='
WHERE
key_id = '7b9247501454c1fb178e75b78e46a09319aab2774db30a541030b92bfeb89e7b'
AND (
token = 'WrmhQAmLGwW375227a2CcYp8a1SvmMhmjlpmwlH3fV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)