UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ilm7zqYnSOwvDV1A0fYdBKTi11hMSNhJcyW2L3b0ac='
WHERE
key_id = 'ef7f54f5b494855a07457ba0ecd3e3cbf0a701ce9ee89c0e6396a15ddc93a67a'
AND (
token = '7ilm7zqYnSOwvDV1A0fYdBKTi11hMSNhJcyW2L3b0ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)