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