UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '30gSbQDJoDqvXrPQi6sp10S6sFgzwPelL4W/xd6eGtc='
WHERE
key_id = 'c02bda5719dae9ed54d88cdf0824383635b0e297cc6100abb1a1a4428d0fc6b2'
AND (
token = '30gSbQDJoDqvXrPQi6sp10S6sFgzwPelL4W/xd6eGtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)