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