UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cFqxvgHpHWCH6543SdpUdTTpoic8lRQnArUOoiF7bYI='
WHERE
key_id = 'a1c4469ceb4f7c08f79a3b0a4dab5b54828e9180a2d89291e00e9bdf6cf8e98c'
AND (
token = 'cFqxvgHpHWCH6543SdpUdTTpoic8lRQnArUOoiF7bYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)