UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cGURK7xxciVZfad341ukiU0cCiwHO8QMwhsU1g+tt08='
WHERE
key_id = 'fa95f61b3ccd4b9ac555e9c17762eaea9be7c4bfb71db9c20a7c844aeded954f'
AND (
token = 'cGURK7xxciVZfad341ukiU0cCiwHO8QMwhsU1g+tt08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)