UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wbPBxPXerE+cdZoYwF+kOpozDjLIfxs+OX1tJiVVI0='
WHERE
key_id = '9fd4eded0bc668ffc34023aff3dae1f5e5ce67b5384315cc0214bd492137ce19'
AND (
token = '8wbPBxPXerE+cdZoYwF+kOpozDjLIfxs+OX1tJiVVI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)