UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N+n9Q+XL5sCJJYDT3IK6h+Z9NUnSzKZwFlPVJpOApao='
WHERE
key_id = '8de7b00c3c41fa9f784cee6b940dcbd607c636407e282ce9f202c985515bb1f0'
AND (
token = 'N+n9Q+XL5sCJJYDT3IK6h+Z9NUnSzKZwFlPVJpOApao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)