UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXDcm0Xxh4wpolY0lA1HxNhELcswPBGN2wOM68j8rgU='
WHERE
key_id = '2e7a8c1c18e48af534dfdb941c6b003f32bf43ebe6c6d2773616263f4dbbfc65'
AND (
token = 'nXDcm0Xxh4wpolY0lA1HxNhELcswPBGN2wOM68j8rgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)