UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qqBAmdxWc4CuEHr2ve/F5HRDeDC86engt7vUg9v8Nuk='
WHERE
key_id = '865135f6f0999ebac216d63e70d2186e9a1661afc01f198877b93a96069eec31'
AND (
token = 'qqBAmdxWc4CuEHr2ve/F5HRDeDC86engt7vUg9v8Nuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)