UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R1pz0B6PSGjVMK/iQEt2ZKUV3bvpZOXsp5mz66EvHsI='
WHERE
key_id = 'c777f2e64fd1a3cf03e9647e8af7fe3c637e2f95e1a2c31874fa98d94cb28994'
AND (
token = 'R1pz0B6PSGjVMK/iQEt2ZKUV3bvpZOXsp5mz66EvHsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)