UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'clpSkSM5vR1OBN1AZybMVxbvpu59TCYHYvZSrae8NVs='
WHERE
key_id = '54a7f06aff86eb0b95e6120b0e038f76b5bb1e35ba94af3117b780479836c7de'
AND (
token = 'clpSkSM5vR1OBN1AZybMVxbvpu59TCYHYvZSrae8NVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)