UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kO8GHWzNIoPZ7FJC57+Oj+WHNmG2142H5ql7o56wTBM='
WHERE
key_id = 'c13008b104f05cc183debe0ff5150416ca92f8ff67494afd3cb246364f588172'
AND (
token = 'kO8GHWzNIoPZ7FJC57+Oj+WHNmG2142H5ql7o56wTBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)