UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mWdwz+9Pr7jNgDfRCjcXYbVyOb3dqOaczbQJCCu801w='
WHERE
key_id = 'f6f3b9622f519f52cb657401d45afd38393f21c4e30237b129012a48f558f5bb'
AND (
token = 'mWdwz+9Pr7jNgDfRCjcXYbVyOb3dqOaczbQJCCu801w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)