UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPD7bRUEvYIBAwEer9RasdKNQU7QN22bPAr543CYGj4='
WHERE
key_id = '02e9d2379aecb3835f44cd3ce4b6415e9ea6ebfd8d40e405d437dc5383397c41'
AND (
token = 'gPD7bRUEvYIBAwEer9RasdKNQU7QN22bPAr543CYGj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)