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