UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZw1m5BH+O0seeMBRetzbz8IuwP/lphIINlDoMkoHM0='
WHERE
key_id = 'fd6e710d7d24ec92a42f36d4c7164f9e44a1eb70255ab92bdcafc7a5f4fd2151'
AND (
token = 'gZw1m5BH+O0seeMBRetzbz8IuwP/lphIINlDoMkoHM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)