UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KiFs7E7uFtZPWeCXoOFYDRtDeZ6T+CmvcK9ZcMceEZg='
WHERE
key_id = '472712e9a92c99543ec7b542b2bedf824c94bdfaa71c1e6bd62c42f35836a602'
AND (
token = 'KiFs7E7uFtZPWeCXoOFYDRtDeZ6T+CmvcK9ZcMceEZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)