UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6z1FHLzwx7buB5pAsGscJjgM+VQkPCZYDyeWgj1PuBk='
WHERE
key_id = '2d0b7ba72a8884ff1e47d32f49f99dc77857eaf6098be1e0da536a6a65bdd9f5'
AND (
token = '6z1FHLzwx7buB5pAsGscJjgM+VQkPCZYDyeWgj1PuBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)