UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IfP1wxkY703pN6xyFnK/YBnzcVrZAe6sBLR5J87DnwY='
WHERE
key_id = '49009e2024f0b7f4164e31483a0f0eb9cc8f5d96597826f33cefc5162180959f'
AND (
token = 'IfP1wxkY703pN6xyFnK/YBnzcVrZAe6sBLR5J87DnwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)