UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N293pNyiJ5aDv8CZSbzqACUJjmA0CWO82iUXU8QShaM='
WHERE
key_id = '39fd5c478b40d304d0dfce0a9a5c43d5f804c30842527c58377382cfb2f1807b'
AND (
token = 'N293pNyiJ5aDv8CZSbzqACUJjmA0CWO82iUXU8QShaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)