UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pTwYytmWINC7ie94cFr9+a2boT8QguN8pagofrex9sE='
WHERE
key_id = 'ee408575bc8f9e1cf32fb1017fd86ced7488c78d1c0eb25c2d352537797f33e2'
AND (
token = 'pTwYytmWINC7ie94cFr9+a2boT8QguN8pagofrex9sE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)