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