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