UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVgLk9bIJucT1PNEUuIX+MxvJfKI0XQl8BBQHpoDMXI='
WHERE
key_id = '7b33adbfee27892c49f3d628dbcd5f8fb0ff15294cc1d573e8f3d5155c28f57a'
AND (
token = 'ZVgLk9bIJucT1PNEUuIX+MxvJfKI0XQl8BBQHpoDMXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)