UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3pObTy4TmhHeMycMW/UHyXk2i3SO+5109Ap7WpaYmRU='
WHERE
key_id = 'd1d0be436afb78a2ec9024c00708bdd4749c4a89fd8f862f5dd29d270f7de953'
AND (
token = '3pObTy4TmhHeMycMW/UHyXk2i3SO+5109Ap7WpaYmRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)