UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZLa6erUssvhqz7nCwvI4Klz4x7GKkSTgRaTYnDWZdLk='
WHERE
key_id = '900dadb5fa4815cc45c7cb843dade410744ef869f9f6f2e159a5afe5a631fc36'
AND (
token = 'ZLa6erUssvhqz7nCwvI4Klz4x7GKkSTgRaTYnDWZdLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)