UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BiGlmKxk+Fa1DgW0bKgbF+BYLLZsEtuwPd6wyV8qmrw='
WHERE
key_id = '0512323bb4e244b51b9aa49a0d38a68ac72b090a5d4434dfbe2d1c96ffb848b2'
AND (
token = 'BiGlmKxk+Fa1DgW0bKgbF+BYLLZsEtuwPd6wyV8qmrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)