UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NdgfHTpfeYc35y4HzQZimiZMk7TAnsZgm849D+/9jM8='
WHERE
key_id = '73178ae5e53133db6488183e263ee81bc1ce843e89310ea878935331454c8455'
AND (
token = 'NdgfHTpfeYc35y4HzQZimiZMk7TAnsZgm849D+/9jM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)