UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXYcuH2+QczBypNruVTefcRgtAQ0YzlzD2OEIL03MAE='
WHERE
key_id = 'dc447eca2dd769f698c42c0965ec5353b12b045dec74235ab4683272e8cd6349'
AND (
token = 'sXYcuH2+QczBypNruVTefcRgtAQ0YzlzD2OEIL03MAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)