UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0EGvwwTk7joGKUIUcLm/92WixRkTAG0F/GGStA6eics='
WHERE
key_id = 'd4ecace415b5b6bb92276cb33b39514cb8c8d0df2f12b3cf477d506972f270d8'
AND (
token = '0EGvwwTk7joGKUIUcLm/92WixRkTAG0F/GGStA6eics='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)